Excel 2007 for Biological and Life Sciences Statistics by Thomas J. Quirk Meghan Quirk & Howard Horton

Author:Thomas J. Quirk, Meghan Quirk & Howard Horton
Language: eng
Format: epub
Publisher: Springer New York, New York, NY

Fig. 5.10Formula Labels for the Two-group t-test

You now need to compute the values of the above formulas in the following cells:D13: the result of the formula needed to compute cell B13 (use 2 decimals)

D16: the result of the formula needed to compute cell B16 (use 2 decimals)

D19: the result of the formula needed to compute cell B19 (use 2 decimals)

D22: =SQRT(D19) (use 2 decimals)

This formula should give you a standard error (s.e.) of 1.98.

D25: 1.96 (Since df = n1 + n2 – 2, this gives df = 109 – 2 = 107, and the

critical t is, therefore, 1.96 in Appendix E.)

D28: =(D4–D5)/D22 (use 2 decimals)

This formula should give you a value for the t-test of: ─ 4.55.

Next, check to see if you have rounded off all figures in D13: D28 to two decimal places (see Fig. 5.11).

Fig. 5.11Results of the t-test Formula for Item #12 for Introductory Biology 101

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.